Create table PowersportsPart.PowersportsPartInfo
(
 PowersportsPart_InfoID int identity(1,1) primary key,
 AutoAccessoryProductType_InfoID int not null,
 PowersportsPartVariationData_InfoID int not null,
 AmperageDimension_InfoID int,
 ModelYear int ,
 Season nvarchar(50),
 PowersportsPartColorSpecificationInfo_InfoID INT,
 Diameter_LengthDimension_InfoID int,
 ItemPackageQuantity int default 1,
 Material nvarchar(50),
 Size nvarchar(50),
 Voltage INT ,
 Wattage int,
 NumberOfGrooves int ,
 ManufacturerWarrantyDescription nvarchar(50),
Position nvarchar(20),
Orientation nvarchar(20),
Profile nvarchar(10),
PulleyType nvarchar(15),
PowersportsPartInterchangeData_InfoID int ,
IsDel bit default 0,
CreateUser nvarchar(20) default 'PU',
CreateTime DATETIME DEFAULT GETDATE(),
UpdateUser nvarchar(20) default 'FL',
UpdateTime datetime default getdate()
)

Create table PowersportsPart.PowersportsPartPartInterchangeDataInfo
(
PowersportsPartPartInterchangeData_InfoID INT IDENTITY(1,1) PRIMARY KEY,
OEManufacturer nvarchar(50) not null,
PartInterchangeInfo nvarchar(50) not null,
IsDel bit default 0,
CreateUser nvarchar(20) default 'PU',
CreateTime DATETIME DEFAULT GETDATE(),
UpdateUser nvarchar(20) default 'FL',
UpdateTime datetime default getdate()
)

Create table PowersportsPart.PowersportsPartColorSpecificationInfo
(
PowersportsPartColorSpecificationInfo_InfoID INT IDENTITY(1,1) PRIMARY KEY,
Color nvarchar(50),
ColorMap nvarchar(50),
IsDel bit default 0,
CreateUser nvarchar(20) default 'PU',
CreateTime DATETIME DEFAULT GETDATE(),
UpdateUser nvarchar(20) default 'FL',
UpdateTime datetime default getdate()
)

Create table PowersportsPart.PowersportsPartVariationDataInfo
(
PowersportsPartVariationData_InfoID int identity(1,1) primary key,
Parentage nvarchar(6) not null,
VariationTheme nvarchar(10) not null,
IsDel bit default 0,
CreateUser nvarchar(20) default 'PU',
CreateTime datetime default getdate(),
UpdateUser nvarchar(20) default 'FL',
UpdateTime datetime default getdate()
)


SELECT * FROM 